SQLDelete

 

The SQLDelete function is a SQL function that deletes the data you have set.

 

void @SQLDelete(int id, string tablename, string where);

 

Parameters

int id : Access number connected by SQLConnect

string tablename : Table Name

string where : where clause

 

Return Value

None

 

Example

@sprintf(buf, "ID=%d", $AddrNum);

@SQLDelete($AddrID, "Table1", buf);

 

Description : Delete the data set to the Data ID of the linked database, table Table1.

 

Related Helps

SQLConnect()

SQLCreateTable()

SQLDisconnect()

SQLExecute()

SQLFirst()

SQLGetPos()

SQLInsert()

SQLLast()

SQLNext()

SQLPrepare()

SQLPrev()

SQLSelect()

SQLSetPos()

SQLUpdate()